home *** CD-ROM | disk | FTP | other *** search
/ Personal Computer World 2007 September / PCWSEP07.iso / Software / Resources / Developers / XAMPP 1.5.4 / Windows installer / xampp-win32-1.5.4-installer.exe / xampp / contrib / interbase.php < prev    next >
Text File  |  2006-03-21  |  718b  |  37 lines
  1. <html>
  2. <head>
  3. <title>PHP und InterBase</title>
  4. </head>
  5. <body>
  6. <h1>PHP und InterBase/Firebird</h1>
  7. <table border="1">
  8. <tr>
  9.     <th>Interpret</th>
  10.     <th>Titel</th>
  11.     <th>Jahr</th>
  12. </tr>
  13. <?php
  14.     $db = ibase_pconnect("/opt/lampp/var/firebird/cdcol.gdb", "oswald", "geheim");
  15.  
  16.     $query = "SELECT * FROM cds";
  17.     $result = ibase_query($query);
  18.     if ($result) {
  19.         while ($row = ibase_fetch_assoc  ($result))
  20.         {
  21.             echo "<tr>";
  22.             echo "<td>".$row['INTERPRET']."</td>";
  23.             echo "<td>".$row['TITEL']."</td>";
  24.             echo "<td>".$row['JAHR']."</td>";
  25.             echo "</tr>";
  26.         }
  27.     }
  28.     else
  29.     {
  30.         echo ibase_errmsg();
  31.     }
  32.  
  33. ?>
  34. </table>
  35. </body>
  36. </html>
  37.